Drop table if exists Contact
create table [dbo].[Contact]
(
	ContactID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
	FirstName VARCHAR(50) NULL,
	SurName VARCHAR(50) NULL, 
	KnownAs VARCHAR(50) NULL,
	OfficePhone VARCHAR(50) NULL, 
	MobilePhone VARCHAR(50) NULL,
	STHomePhone VARCHAR(50) NULL,
	Email VARCHAR(50) NULL,
	ManagerID INT NULL FOREIGN KEY REFERENCES Programme(ProgrammeID),
	ContactType VARCHAR(50) NULL,
	BestContactMethod VARCHAR(50) NULL,
	JobRole VARCHAR(50) NULL,
	Workbase VARCHAR(50) NULL,
	JobTitle VARCHAR(50) NULL,
	IsActive BIT NULL,	
)